﻿CREATE TABLE [dbo].[tblHoSoHKD]
(
	[Stt_Rec] [nvarchar] (10) NOT NULL,	
	[Ma_Hs] [numeric] (10, 0) NOT NULL,
	[So_Gp] [nvarchar] (15) NULL,
	[Ho_Ten] [nvarchar] (63) NULL,
	[Ngay_Sinh] [smalldatetime]  NULL,
	[Gioi_Tinh] [nvarchar] (5) NULL,
	[Dan_Toc] [nvarchar] (47) NULL,
	[Quoc_Tich] [nvarchar] (47) NULL,
	[So_Cmnd] [nvarchar] (12) NULL,
	[Ngay_Cmnd] [smalldatetime] NULL,
	[Noi_Cmnd] [nvarchar] (47) NULL,
	[Ten_Gtk] [nvarchar] (47) NULL,
	[So_GtK] [nvarchar] (23) NULL,
	[Ngay_Gtk] [smalldatetime] NULL,
	[Han_Gtk] [smalldatetime] NULL,
	[Noi_Gtk] [nvarchar] (47)  NULL,
	[HoKhau_Tt] [nvarchar] (127)  NULL,
	[NoiO_Ht] [nvarchar] (127) NULL,
	[Dien_Thoai] [nvarchar] (47) NULL,
	[Fax] [nvarchar] (47) NULL,
	[Email] [nvarchar] (47)  NULL,
	[WebSite] [nvarchar] (47)  NULL,
	[Ten_HoKd] [nvarchar] (127) NULL,
	[Dia_Diem] [nvarchar] (127) NULL,
	[Noi_dung] [nvarchar] (255) NULL,
	[Dt_Kd] [nvarchar] (23)  NULL,
	[Ma_Px] [nvarchar] (15) NOT NULL,
	[DienThoai_Kd] [nvarchar] (47)  NULL,
	[Fax_Kd] [nvarchar] (47)  NULL,
	[Email_Kd] [nvarchar] (47)  NULL,
	[Website_Kd] [nvarchar] (47)  NULL,	
	[Von_Kd] [numeric] (18, 2) NULL,
	[Ma_Tt] [nvarchar] (1) NULL,
	[Ma_Tt2] [nvarchar] (1) NULL,
	[TinhTrang_MaTt] [int] NULL,	
	[Ghi_Chu] [nvarchar](512) NULL,
	[Ngay_Cap] [smalldatetime] NULL,	
	[Ngay_TN]  [smalldatetime] NULL,
	[Ngay_TN2] [smalldatetime] NULL,
	[Ngay_CD]  [smalldatetime] NULL,
	[HoSo_HT]  [nvarchar] (10) NULL,
	[User0] [nvarchar] (23) NOT NULL,
	[Date0] [datetime] NOT NULL,
	[Client0] [nvarchar] (47) NOT NULL
);
